package com.wisemoresystem.seal.service;

import java.util.List;
import java.util.Map;

import org.springframework.stereotype.Service;

import com.wisemoresystem.seal.base.service.BaseService;

@Service
public class BankWktimeService extends BaseService {

	public List<Map<String, Object>> selectBankWktime(String bank_id){
		
		String  sql="select t.*,tb.name,tu.uname from t_bank_wktime t "
				+ " left join t_bank tb on t.bank_id=tb._id "
				+ " left join t_user tu on t.user_id=tu._id "
				+ " where t.status=0 and t.bank_id=? order by t.created asc";
		
		List<Map<String, Object>> list = jt.queryForList(sql,new String[]{bank_id});
		return list;
	}
}
